package test;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

public class PostgresConnection {

	private static String driverName = "org.postgresql.Driver";
	private static String host = "localhost";
	private static String port = "5432";
	private static String dbName = "gbv";
	private static String username = "gbv";
	private static String password = "gbv";

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		System.out.println("-------- PostgreSQL "
				+ "JDBC Connection Testing ------------");

		try {

			Class.forName(driverName);

		} catch (ClassNotFoundException e) {

			System.out.println("Where is your PostgreSQL JDBC Driver? "
					+ "Include in your library path!");
			e.printStackTrace();
			return;

		}

		System.out.println("PostgreSQL JDBC Driver Registered!");

		Connection connection = null;

		try {

			connection = DriverManager.getConnection("jdbc:postgresql://"+host+":"+port+"/"+dbName,username ,password);

		} catch (SQLException e) {

			System.out.println("Connection Failed! Check output console");
			e.printStackTrace();
			return;

		}

		if (connection != null) {
			System.out.println("You made it, take control your database now!");
		} else {
			System.out.println("Failed to make connection!");
		}
	}

}
